Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	488244
Missing cells	5319
Missing cells (%)	0.1%
Duplicate rows	524
Duplicate rows (%)	0.1%
Total size in memory	63.3 MiB
Average record size in memory	136.0 B

Variable types

NUM	9
CAT	8

Warnings

Dataset has 524 (0.1%) duplicate rows	Duplicates
`Hotel_Address` has a high cardinality: 1422 distinct values	High cardinality
`Review_Date` has a high cardinality: 731 distinct values	High cardinality
`Hotel_Name` has a high cardinality: 1421 distinct values	High cardinality
`Reviewer_Nationality` has a high cardinality: 226 distinct values	High cardinality
`Negative_Review` has a high cardinality: 311852 distinct values	High cardinality
`Positive_Review` has a high cardinality: 391112 distinct values	High cardinality
`Tags` has a high cardinality: 53140 distinct values	High cardinality
`days_since_review` has a high cardinality: 731 distinct values	High cardinality
`Review_Total_Negative_Word_Counts` has 121589 (24.9%) zeros	Zeros
`Review_Total_Positive_Word_Counts` has 33837 (6.9%) zeros	Zeros

Reproduction

Analysis started	2020-12-09 14:55:01.772815
Analysis finished	2020-12-09 14:55:47.231073
Duration	45.46 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Hotel_Address
Categorical

HIGH CARDINALITY

Distinct	1422
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom	4789
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	4256
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	3578
7 Pepys Street City of London London EC3N 4AF United Kingdom	3212
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom	2958
Other values (1417)	469451

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom	4789	1.0%
372 Strand Westminster Borough London WC2R 0JJ United Kingdom	4256	0.9%
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom	3578	0.7%
7 Pepys Street City of London London EC3N 4AF United Kingdom	3212	0.7%
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom	2958	0.6%
225 Edgware Road Westminster Borough London W2 1JU United Kingdom	2628	0.5%
4 18 Harrington Gardens Kensington and Chelsea London SW7 4LH United Kingdom	2565	0.5%
1 Waterview Drive Greenwich London SE10 0TW United Kingdom	2551	0.5%
27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom	2288	0.5%
Lakeside Way Brent London HA9 0BU United Kingdom	2227	0.5%
Other values (1412)	457192	93.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	96
Median length	60
Mean length	60.17488592
Min length	34

Additional_Number_of_Scoring
Real number (ℝ_≥0)

Distinct	471
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	481.438969
Minimum	1
Maximum	2682
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	57
Q1	168
median	338
Q3	639
95-th percentile	1427
Maximum	2682
Range	2681
Interquartile range (IQR)	471

Descriptive statistics

Standard deviation	467.9015792
Coefficient of variation (CV)	0.9718813999
Kurtosis	5.734583708
Mean	481.438969
Median Absolute Deviation (MAD)	200
Skewness	2.149221449
Sum	235059688
Variance	218931.8878
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2682	4789	1.0%
2288	4256	0.9%
1831	3578	0.7%
1936	3212	0.7%
256	3079	0.6%
1274	2958	0.6%
832	2934	0.6%
211	2858	0.6%
1485	2628	0.5%
704	2600	0.5%
Other values (461)	455352	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	13	< 0.1%
4	12	< 0.1%
5	39	< 0.1%
6	118	< 0.1%
7	56	< 0.1%

Value	Count	Frequency (%)
2682	4789	1.0%
2288	4256	0.9%
1936	3212	0.7%
1831	3578	0.7%
1485	2628	0.5%

Review_Date
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

8/2/2017	2453
9/15/2016	2183
4/5/2017	2169
8/30/2016	1860
2/16/2016	1855
Other values (726)	477724

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
8/2/2017	2453	0.5%
9/15/2016	2183	0.4%
4/5/2017	2169	0.4%
8/30/2016	1860	0.4%
2/16/2016	1855	0.4%
7/5/2016	1807	0.4%
5/31/2016	1776	0.4%
7/12/2016	1724	0.4%
12/5/2016	1699	0.3%
8/2/2016	1693	0.3%
Other values (721)	469025	96.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	9
Mean length	8.931763626
Min length	8

Average_Score
Real number (ℝ_≥0)

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.401896593
Minimum	6.4
Maximum	9.8
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	6.4
5-th percentile	7.4
Q1	8.1
median	8.4
Q3	8.8
95-th percentile	9.2
Maximum	9.8
Range	3.4
Interquartile range (IQR)	0.7

Descriptive statistics

Standard deviation	0.5508706658
Coefficient of variation (CV)	0.06556503758
Kurtosis	0.282624906
Mean	8.401896593
Median Absolute Deviation (MAD)	0.4
Skewness	-0.5291766522
Sum	4102175.6
Variance	0.3034584905
Monotocity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
8.4	38495	7.9%
8.5	37159	7.6%
8.6	35994	7.4%
8.1	34040	7.0%
8.2	33869	6.9%
8.7	31916	6.5%
8.3	30481	6.2%
8.8	29932	6.1%
8.9	27783	5.7%
9.1	21123	4.3%
Other values (23)	167452	34.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.4	1163	0.2%
6.6	400	0.1%
6.7	965	0.2%
6.8	1335	0.3%
6.9	1737	0.4%

Value	Count	Frequency (%)
9.8	28	< 0.1%
9.6	915	0.2%
9.5	1207	0.2%
9.4	9126	1.9%
9.3	12416	2.5%

Hotel_Name
Categorical

HIGH CARDINALITY

Distinct	1421
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

Britannia International Hotel Canary Wharf	4789
Strand Palace Hotel	4256
Copthorne Tara Hotel London Kensington	3578
DoubleTree by Hilton Hotel London Tower of London	3212
Grand Royale London Hyde Park	2958
Other values (1416)	469451

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Britannia International Hotel Canary Wharf	4789	1.0%
Strand Palace Hotel	4256	0.9%
Copthorne Tara Hotel London Kensington	3578	0.7%
DoubleTree by Hilton Hotel London Tower of London	3212	0.7%
Grand Royale London Hyde Park	2958	0.6%
Hilton London Metropole	2628	0.5%
Millennium Gloucester Hotel London	2565	0.5%
Intercontinental London The O2	2551	0.5%
Park Grand Paddington Court	2288	0.5%
Hilton London Wembley	2227	0.5%
Other values (1411)	457192	93.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	60
Median length	24
Mean length	25.31215745
Min length	2

Reviewer_Nationality
Categorical

HIGH CARDINALITY

Distinct	226
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

United Kingdom	235230
United States of America	33731
Australia	20569
Ireland	14032
United Arab Emirates	9666
Other values (221)	175016

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
United Kingdom	235230	48.2%
United States of America	33731	6.9%
Australia	20569	4.2%
Ireland	14032	2.9%
United Arab Emirates	9666	2.0%
Saudi Arabia	8494	1.7%
Netherlands	8226	1.7%
Switzerland	7938	1.6%
Canada	7515	1.5%
Germany	7312	1.5%
Other values (216)	135531	27.8%

Frequencies of value counts

Unique

Unique	11 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	38
Median length	16
Mean length	14.08348285
Min length	1

Negative_Review
Categorical

HIGH CARDINALITY

Distinct	311852
Distinct (%)	63.9%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

No Negative	121589
Nothing	13706
Nothing	4029
nothing	2106
N A	981
Other values (311847)	345833

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Negative	121589	24.9%
Nothing	13706	2.8%
Nothing	4029	0.8%
nothing	2106	0.4%
N A	981	0.2%
None	935	0.2%
	782	0.2%
N a	491	0.1%
Breakfast	368	0.1%
Small room	355	0.1%
Other values (311842)	342902	70.2%

Frequencies of value counts

Unique

Unique	305692 ?
Unique (%)	62.6%

Histogram of lengths of the category

Length

Max length	1966
Median length	41
Mean length	93.31080566
Min length	1

Review_Total_Negative_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	401
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18.44131418
Minimum	0
Maximum	408
Zeros	121589
Zeros (%)	24.9%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	23
95-th percentile	68
Maximum	408
Range	408
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	29.57228685
Coefficient of variation (CV)	1.603588907
Kurtosis	31.63902257
Mean	18.44131418
Median Absolute Deviation (MAD)	9
Skewness	4.420730067
Sum	9003861
Variance	874.5201498
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	121589	24.9%
2	23438	4.8%
3	17265	3.5%
6	16846	3.5%
5	15887	3.3%
7	15263	3.1%
4	14297	2.9%
8	13981	2.9%
9	12942	2.7%
10	11751	2.4%
Other values (391)	224985	46.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	121589	24.9%
2	23438	4.8%
3	17265	3.5%
4	14297	2.9%
5	15887	3.3%

Value	Count	Frequency (%)
408	1	< 0.1%
403	2	< 0.1%
402	1	< 0.1%
401	1	< 0.1%
399	2	< 0.1%

Total_Number_of_Reviews
Real number (ℝ_≥0)

Distinct	1095
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2573.642566
Minimum	43
Maximum	9568
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	43
5-th percentile	423
Q1	1140
median	2058
Q3	3550
95-th percentile	6977
Maximum	9568
Range	9525
Interquartile range (IQR)	2410

Descriptive statistics

Standard deviation	1947.060953
Coefficient of variation (CV)	0.756538992
Kurtosis	1.805900783
Mean	2573.642566
Median Absolute Deviation (MAD)	1059
Skewness	1.37410498
Sum	1256565541
Variance	3791046.353
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9086	4789	1.0%
9568	4256	0.9%
7105	3578	0.7%
7491	3212	0.7%
6539	2958	0.6%
6977	2628	0.5%
5726	2565	0.5%
4204	2551	0.5%
6608	2288	0.5%
4305	2227	0.5%
Other values (1085)	457192	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
43	12	< 0.1%
45	12	< 0.1%
49	40	< 0.1%
51	13	< 0.1%
54	13	< 0.1%

Value	Count	Frequency (%)
9568	4256	0.9%
9086	4789	1.0%
8177	1809	0.4%
7586	1686	0.3%
7491	3212	0.7%

Positive_Review
Categorical

HIGH CARDINALITY

Distinct	391112
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

No Positive	33837
Location	8773
Everything	2160
location	1594
Nothing	1171
Other values (391107)	440709

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
No Positive	33837	6.9%
Location	8773	1.8%
Everything	2160	0.4%
location	1594	0.3%
Nothing	1171	0.2%
The location	1091	0.2%
Great location	997	0.2%
Good location	891	0.2%
Location	874	0.2%
Everything	577	0.1%
Other values (391102)	436279	89.4%

Frequencies of value counts

Unique

Unique	382141 ?
Unique (%)	78.3%

Histogram of lengths of the category

Length

Max length	1960
Median length	59
Mean length	94.73031927
Min length	1

Review_Total_Positive_Word_Counts
Real number (ℝ_≥0)

ZEROS

Distinct	364
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	17.79280399
Minimum	0
Maximum	395
Zeros	33837
Zeros (%)	6.9%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	11
Q3	22
95-th percentile	56
Maximum	395
Range	395
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.8136532
Coefficient of variation (CV)	1.225981763
Kurtosis	32.88995015
Mean	17.79280399
Median Absolute Deviation (MAD)	7
Skewness	4.188480032
Sum	8687212
Variance	475.8354661
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33837	6.9%
6	25471	5.2%
5	25380	5.2%
4	23313	4.8%
7	23249	4.8%
8	22000	4.5%
3	21364	4.4%
9	20021	4.1%
2	19803	4.1%
10	18632	3.8%
Other values (354)	255173	52.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33837	6.9%
2	19803	4.1%
3	21364	4.4%
4	23313	4.8%
5	25380	5.2%

Value	Count	Frequency (%)
395	1	< 0.1%
386	1	< 0.1%
384	2	< 0.1%
383	2	< 0.1%
382	1	< 0.1%

Total_Number_of_Reviews_Reviewer_Has_Given
Real number (ℝ_≥0)

Distinct	196
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	7.115956604
Minimum	1
Maximum	355
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	8
95-th percentile	26
Maximum	355
Range	354
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	10.99577179
Coefficient of variation (CV)	1.545227494
Kurtosis	52.97586383
Mean	7.115956604
Median Absolute Deviation (MAD)	2
Skewness	5.141920738
Sum	3474316
Variance	120.9069972
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	147323	30.2%
2	63774	13.1%
3	44536	9.1%
4	33103	6.8%
5	26104	5.3%
6	21361	4.4%
7	17567	3.6%
8	15203	3.1%
9	12770	2.6%
10	11003	2.3%
Other values (186)	95499	19.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	147323	30.2%
2	63774	13.1%
3	44536	9.1%
4	33103	6.8%
5	26104	5.3%

Value	Count	Frequency (%)
355	1	< 0.1%
330	1	< 0.1%
315	4	< 0.1%
297	2	< 0.1%
281	2	< 0.1%

Reviewer_Score
Real number (ℝ_≥0)

Distinct	37
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	8.402732246
Minimum	2.5
Maximum	10
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	2.5
5-th percentile	5
Q1	7.5
median	8.8
Q3	9.6
95-th percentile	10
Maximum	10
Range	7.5
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.635967246
Coefficient of variation (CV)	0.1946946777
Kurtosis	0.983732752
Mean	8.402732246
Median Absolute Deviation (MAD)	1.2
Skewness	-1.198513722
Sum	4102575.2
Variance	2.67638883
Monotocity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
10	110686	22.7%
9.6	67597	13.8%
9.2	55464	11.4%
8.8	43754	9.0%
8.3	38802	7.9%
7.5	32900	6.7%
7.9	31180	6.4%
7.1	23400	4.8%
6.7	17661	3.6%
6.3	14041	2.9%
Other values (27)	52758	10.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.5	2046	0.4%
2.9	1484	0.3%
3	34	< 0.1%
3.1	8	< 0.1%
3.3	2625	0.5%

Value	Count	Frequency (%)
10	110686	22.7%
9.6	67597	13.8%
9.5	690	0.1%
9.4	57	< 0.1%
9.2	55464	11.4%

Tags
Categorical

HIGH CARDINALITY

Distinct	53140
Distinct (%)	10.9%
Missing	1
Missing (%)	< 0.1%
Memory size	3.7 MiB

[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4705
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4661
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4220
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	3959
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2949
Other values (53135)	467749

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4705	1.0%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4661	1.0%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	4220	0.9%
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	3959	0.8%
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2949	0.6%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2934	0.6%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2782	0.6%
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ']	2575	0.5%
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ']	2478	0.5%
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	2291	0.5%
Other values (53130)	454689	93.1%

Frequencies of value counts

Unique

Unique	28802 ?
Unique (%)	5.9%

Histogram of lengths of the category

Length

Max length	213
Median length	108
Mean length	102.4303627
Min length	3

days_since_review
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	3.7 MiB

1 days	2453
322 day	2183
120 day	2169
338 day	1860
534 day	1855
Other values (726)	477723

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1 days	2453	0.5%
322 day	2183	0.4%
120 day	2169	0.4%
338 day	1860	0.4%
534 day	1855	0.4%
394 day	1807	0.4%
429 day	1776	0.4%
387 day	1724	0.4%
241 day	1699	0.3%
366 day	1693	0.3%
Other values (721)	469024	96.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	6.984126789
Min length	3

lat
Real number (ℝ_≥0)

Distinct	1404
Distinct (%)	0.3%
Missing	2657
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%

Mean	49.47479932
Minimum	41.3283758
Maximum	52.4001813
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	41.3283758
5-th percentile	41.386136
Q1	48.8346811
median	51.5013149
Q3	51.5166755
95-th percentile	52.369391
Maximum	52.4001813
Range	11.0718055
Interquartile range (IQR)	2.6819944

Descriptive statistics

Standard deviation	3.484356032
Coefficient of variation (CV)	0.07042688561
Kurtosis	0.7584232953
Mean	49.47479932
Median Absolute Deviation (MAD)	0.0445327
Skewness	-1.452080311
Sum	24024319.38
Variance	12.14073696
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.5019097	4789	1.0%
51.5110993	4256	0.9%
51.499046	3578	0.7%
51.5108412	3212	0.7%
51.5109945	2958	0.6%
51.5195688	2628	0.5%
51.4935083	2565	0.5%
51.5024348	2551	0.5%
51.5135555	2288	0.5%
51.5576962	2227	0.5%
Other values (1394)	454535	93.1%
(Missing)	2657	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
41.3283758	572	0.1%
41.368437	575	0.1%
41.3703041	229	< 0.1%
41.371308	1082	0.2%
41.3725246	120	< 0.1%

Value	Count	Frequency (%)
52.4001813	312	0.1%
52.3924898	467	0.1%
52.3923684	143	< 0.1%
52.3872884	856	0.2%
52.3856494	1071	0.2%

lng
Real number (ℝ)

Distinct	1404
Distinct (%)	0.3%
Missing	2657
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%

Mean	2.630325181
Minimum	-0.3192925
Maximum	16.4217627
Zeros	0
Zeros (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	-0.3192925
5-th percentile	-0.1949706
Q1	-0.1444623
median	-0.0071375
Q3	2.3556545
95-th percentile	16.3546297
Maximum	16.4217627
Range	16.7410552
Interquartile range (IQR)	2.5001168

Descriptive statistics

Standard deviation	4.43069956
Coefficient of variation (CV)	1.684468366
Kurtosis	3.513074748
Mean	2.630325181
Median Absolute Deviation (MAD)	0.2217223
Skewness	2.056953327
Sum	1277251.714
Variance	19.6310986
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.0232208	4789	1.0%
-0.1208673	4256	0.9%
-0.1917073	3578	0.7%
-0.0780581	3212	0.7%
-0.1863417	2958	0.6%
-0.170521	2628	0.5%
-0.1834346	2565	0.5%
-0.0002497	2551	0.5%
-0.180002	2288	0.5%
-0.2835263	2227	0.5%
Other values (1394)	454535	93.1%
(Missing)	2657	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.3192925	391	0.1%
-0.306071	128	< 0.1%
-0.2915052	385	0.1%
-0.290706	680	0.1%
-0.2864945	1212	0.2%

Value	Count	Frequency (%)
16.4217627	426	0.1%
16.4200957	431	0.1%
16.4133973	191	< 0.1%
16.4129493	501	0.1%
16.4116997	92	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng
0	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	8/3/2017	7.7	Hotel Arena	Russia	I am so angry that i made this post available via all possible sites i use when planing my trips so no one will make the mistake of booking this place I made my booking via booking com We stayed for 6 nights in this hotel from 11 to 17 July Upon arrival we were placed in a small room on the 2nd floor of the hotel It turned out that this was not the room we booked I had specially reserved the 2 level duplex room so that we would have a big windows and high ceilings The room itself was ok if you don t mind the broken window that can not be closed hello rain and a mini fridge that contained some sort of a bio weapon at least i guessed so by the smell of it I intimately asked to change the room and after explaining 2 times that i booked a duplex btw it costs the same as a simple double but got way more volume due to the high ceiling was offered a room but only the next day SO i had to check out the next day before 11 o clock in order to get the room i waned to Not the best way to begin your holiday So we had to wait till 13 00 in order to check in my new room what a wonderful waist of my time The room 023 i got was just as i wanted to peaceful internal garden view big window We were tired from waiting the room so we placed our belongings and rushed to the city In the evening it turned out that there was a constant noise in the room i guess it was made by vibrating vent tubes or something it was constant and annoying as hell AND it did not stop even at 2 am making it hard to fall asleep for me and my wife I have an audio recording that i can not attach here but if you want i can send it via e mail The next day the technician came but was not able to determine the cause of the disturbing sound so i was offered to change the room once again the hotel was fully booked and they had only 1 room left the one that was smaller but seems newer	397	1403	Only the park outside of the hotel was beautiful	11.0	7.0	2.9	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 6 nights ']	0 days	52.360576	4.915968
1	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	8/3/2017	7.7	Hotel Arena	Ireland	No Negative	0	1403	No real complaints the hotel was great great location surroundings rooms amenities and service Two recommendations however firstly the staff upon check in are very confusing regarding deposit payments and the staff offer you upon checkout to refund your original payment and you can make a new one Bit confusing Secondly the on site restaurant is a bit lacking very well thought out and excellent quality food for anyone of a vegetarian or vegan background but even a wrap or toasted sandwich option would be great Aside from those minor minor things fantastic spot and will be back when i return to Amsterdam	105.0	7.0	7.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 4 nights ']	0 days	52.360576	4.915968
2	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/31/2017	7.7	Hotel Arena	Australia	Rooms are nice but for elderly a bit difficult as most rooms are two story with narrow steps So ask for single level Inside the rooms are very very basic just tea coffee and boiler and no bar empty fridge	42	1403	Location was good and staff were ok It is cute hotel the breakfast range is nice Will go back	21.0	9.0	7.1	[' Leisure trip ', ' Family with young children ', ' Duplex Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	3 days	52.360576	4.915968
3	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/31/2017	7.7	Hotel Arena	United Kingdom	My room was dirty and I was afraid to walk barefoot on the floor which looked as if it was not cleaned in weeks White furniture which looked nice in pictures was dirty too and the door looked like it was attacked by an angry dog My shower drain was clogged and the staff did not respond to my request to clean it On a day with heavy rainfall a pretty common occurrence in Amsterdam the roof in my room was leaking luckily not on the bed you could also see signs of earlier water damage I also saw insects running on the floor Overall the second floor of the property looked dirty and badly kept On top of all of this a repairman who came to fix something in a room next door at midnight was very noisy as were many of the guests I understand the challenges of running a hotel in an old building but this negligence is inconsistent with prices demanded by the hotel On the last night after I complained about water damage the night shift manager offered to move me to a different room but that offer came pretty late around midnight when I was already in bed and ready to sleep	210	1403	Great location in nice surroundings the bar and restaurant are nice and have a lovely outdoor area The building also has quite some character	26.0	1.0	3.8	[' Leisure trip ', ' Solo traveler ', ' Duplex Double Room ', ' Stayed 3 nights ']	3 days	52.360576	4.915968
4	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/24/2017	7.7	Hotel Arena	New Zealand	You When I booked with your company on line you showed me pictures of a room I thought I was getting and paying for and then when we arrived that s room was booked and the staff told me we could only book the villa suite theough them directly Which was completely false advertising After being there we realised that you have grouped lots of rooms on the photos together leaving me the consumer confused and extreamly disgruntled especially as its my my wife s 40th birthday present Please make your website more clear through pricing and photos as again I didn t really know what I was paying for and how much it had wnded up being Your photos told me I was getting something I wasn t Not happy and won t be using you again	140	1403	Amazing location and building Romantic setting	8.0	3.0	6.7	[' Leisure trip ', ' Couple ', ' Suite ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	10 days	52.360576	4.915968
5	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/24/2017	7.7	Hotel Arena	Poland	Backyard of the hotel is total mess shouldn t happen in hotel with 4 stars	17	1403	Good restaurant with modern design great chill out place Great park nearby the hotel and awesome main stairs	20.0	1.0	6.7	[' Leisure trip ', ' Group ', ' Duplex Double Room ', ' Stayed 1 night ']	10 days	52.360576	4.915968
6	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/17/2017	7.7	Hotel Arena	United Kingdom	Cleaner did not change our sheet and duvet everyday but just made bed They also didn t clean the floor and changed the body gel when we run out of it	33	1403	The room is spacious and bright The hotel is located in a quiet and beautiful park	18.0	6.0	4.6	[' Leisure trip ', ' Group ', ' Duplex Twin Room ', ' Stayed 5 nights ', ' Submitted from a mobile device ']	17 days	52.360576	4.915968
7	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/17/2017	7.7	Hotel Arena	United Kingdom	Apart from the price for the brekfast Everything very good	11	1403	Good location Set in a lovely park friendly staff Food high quality We Oth enjoyed the breakfast	19.0	1.0	10.0	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	17 days	52.360576	4.915968
8	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/9/2017	7.7	Hotel Arena	Belgium	Even though the pictures show very clean rooms the actual room was quit dirty and outlived Also check in is at 15 o clock but our room was not ready at that time	34	1403	No Positive	0.0	3.0	6.5	[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	25 days	52.360576	4.915968
9	s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands	194	7/8/2017	7.7	Hotel Arena	Norway	The aircondition makes so much noise and its hard to sleep at night	15	1403	The room was big enough and the bed is good The breakfast food and service on the hotel is good outside the hotel there is a big park which is very good for walk in the morning and evening Many people are having picnics and do some bicycling	50.0	1.0	7.9	[' Leisure trip ', ' Couple ', ' Large King Room ', ' Stayed 7 nights ']	26 days	52.360576	4.915968

Last rows

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng
488234	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/22/2015	9.0	Senato Hotel Milano	Bulgaria	Non	2	1031	Very modern rooms comfortable bed Perfect breacfast great location	11.0	11.0	9.6	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	620 day	45.471406	9.19653
488235	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/21/2015	9.0	Senato Hotel Milano	United States of America	No Negative	0	1031	Very helpful people A lovely design of the rooms and public spaces	14.0	1.0	8.8	[' Business trip ', ' Group ', ' Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']	621 day	45.471406	9.19653
488236	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/19/2015	9.0	Senato Hotel Milano	United States of America	No Negative	0	1031	a little far from subway but very close to the main fashion area	15.0	7.0	9.2	[' Leisure trip ', ' Couple ', ' Double Room with Terrace ', ' Stayed 1 night ']	623 day	45.471406	9.19653
488237	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/17/2015	9.0	Senato Hotel Milano	Hong Kong	No Negative	0	1031	Easy to access all the major area Staffs are nice Room r tidy with all the essential	19.0	1.0	8.3	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 4 nights ', ' Submitted from a mobile device ']	625 day	45.471406	9.19653
488238	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/16/2015	9.0	Senato Hotel Milano	Belgium	No Negative	0	1031	Beautiful design perfect location great breakfast And friendly staf	11.0	29.0	10.0	[' Leisure trip ', ' Family with older children ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	626 day	45.471406	9.19653
488239	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/12/2015	9.0	Senato Hotel Milano	Saudi Arabia	The room was very small	7	1031	The location and cleanless	5.0	9.0	6.3	[' Leisure trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night ']	630 day	45.471406	9.19653
488240	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/12/2015	9.0	Senato Hotel Milano	United States of America	The pendant lights at the night stand only worked one side Far walk from subway	17	1031	Nicely designed hotel Good location near the action	10.0	7.0	8.8	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	630 day	45.471406	9.19653
488241	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/10/2015	9.0	Senato Hotel Milano	Turkey	No Negative	0	1031	Rooms Breakfast Location	4.0	3.0	10.0	[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 3 nights ']	632 day	45.471406	9.19653
488242	Via Senato 22 Milan City Center 20121 Milan Italy	116	11/8/2015	9.0	Senato Hotel Milano	India	No Negative	0	1031	Excellent ambience created by very thoughtful interior design	10.0	4.0	9.2	[' Leisure trip ', ' Solo traveler ', ' Classic Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	634 day	45.471406	9.19653
488243	Via Senato 22 Milan City Center 20121 Milan Italy	116	10/20/2015	9.0	Senato Hotel Milano	Egypt	No Negative	0	1031	Room and bathroom were really comfortable and ver	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequent

	Hotel_Address	Additional_Number_of_Scoring	Review_Date	Average_Score	Hotel_Name	Reviewer_Nationality	Negative_Review	Review_Total_Negative_Word_Counts	Total_Number_of_Reviews	Positive_Review	Review_Total_Positive_Word_Counts	Total_Number_of_Reviews_Reviewer_Has_Given	Reviewer_Score	Tags	days_since_review	lat	lng	count
0	100 110 Euston Road Camden London NW1 2AJ United Kingdom	728	2/25/2017	8.9	Pullman London St Pancras	China	none	2	3168	good location and super nice staff room is big and great	13.0	39.0	9.6	[' Business trip ', ' Solo traveler ', ' Classic King Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']	159 day	51.528677	-0.128349	2
1	16 22 Great Russell Street Camden London WC1B 3NN United Kingdom	300	7/27/2017	9.0	The Bloomsbury Hotel	Israel	No Negative	0	1254	The attention received by Sebastian and his team was exceptional	12.0	4.0	9.6	[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	7 days	51.517167	-0.129053	2
2	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	Albania	They didnt change the sheets They also had a minibar coca and nestea cannets They didnt tell us that it was with payment and we had to pay 30 euros for 5 of them What an abusive bill	40	165	The room was cozy and pretty	7.0	3.0	5.8	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 3 nights ']	293 day	48.887128	2.314205	2
3	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	Iran	Evry thing was wrong Cold room Dark room No refrigetor in room No ac Evry thing was baaaaaaad Very bad	21	165	This hotel was terrible this place worst place in paris Hostel is better than this place I m sorry for myself to spend my time in this place	29.0	2.0	2.5	[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	293 day	48.887128	2.314205	2
4	167 rue de Rome 17th arr 75017 Paris France	11	10/14/2016	6.8	Villa Eugenie	United Kingdom	Evry thing of this place i can t name horlrel to this place was wrong and out of repair all lamp were nt work 2nights i got cold in cold room Ac not working i so sorry for my self that i had to spend my time in this ruin place 4star hotel has nt refrigerator	58	165	This hotel is worst hotel Its terrible	9.0	1.0	2.5	[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	293 day	48.887128	2.314205	2
5	167 rue de Rome 17th arr 75017 Paris France	11	10/18/2016	6.8	Villa Eugenie	Israel	No Negative	0	165	the room was very french and beautiful it was good location and I enjoyed to stay there	18.0	1.0	9.2	[' Leisure trip ', ' Couple ', ' Twin Room ', ' Stayed 3 nights ']	289 day	48.887128	2.314205	2
6	167 rue de Rome 17th arr 75017 Paris France	11	10/18/2016	6.8	Villa Eugenie	United Kingdom	No internet it was important for me for my business Really Small Room Very Bad Location No Shampoo and staff etc You need to call them to bring All Bad sorry	32	165	Didier was friendly and good	7.0	12.0	2.5	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 4 nights ']	289 day	48.887128	2.314205	2
7	167 rue de Rome 17th arr 75017 Paris France	11	10/19/2016	6.8	Villa Eugenie	Switzerland	Wifi was not working	6	165	No Positive	0.0	1.0	7.9	[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 2 nights ']	288 day	48.887128	2.314205	2
8	167 rue de Rome 17th arr 75017 Paris France	11	10/2/2016	6.8	Villa Eugenie	Qatar	Staff very rude My credit card was charged Before my stay and while Checking out they charged me again when I told the receptionist about it her answer was I m not trying to steal your money madam in a ver un polite way Blaming my Bank about it Very poor selection for breakfast	56	165	Nothing	3.0	8.0	5.0	[' Leisure trip ', ' Family with young children ', ' Two Connecting Double Rooms ', ' Stayed 2 nights ', ' Submitted from a mobile device ']	305 day	48.887128	2.314205	2
9	167 rue de Rome 17th arr 75017 Paris France	11	10/20/2016	6.8	Villa Eugenie	Lithuania	We booked hotel for 3 nights and there was no normal internet connection From all trip time we had internet only for 1 2 huors Also there is very noisy almoust impossible to sleep with open window	39	165	Good place	4.0	9.0	6.7	[' Business trip ', ' Group ', ' Superior Double Room ', ' Stayed 3 nights ']	287 day	48.887128	2.314205	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent